Excel 2016 - Applying Custom and Conditional Formats and Validating Data
      The "Excel 2016 - Applying Custom and Conditional Formats and Validating Data" lesson covers the following topics:
  • Custom and Conditional Formats
  • Validating Data
      
      Custom and Conditional Formats      
      Upon successful completion you will be able to:

1. Apply Numeric Formats;
2. Apply Currency Formats;
3. Apply Accounting Formats;
4. Create Custom Formats;
5. Use Conditional Formatting;
6. Create Formatting Rules;
7. Display Icon Sets;
8. Clear Rules;
9. Use Data Bars.


      
      Validating Data      
      Upon successful completion you will be able to:

1. Use the Data Validation feature;
2. Set Validation Criteria;
3. Create Input Messages;
4. Create Error Alert Messages;
5. Create Named Ranges;
6. Create Data Entry Lists;
7. Enter Data Using Lists.
      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2016 - Applying Custom and Conditional Formats and Validating Data :
Program Training Courses - Microsoft Excel 2016 :
Office Suite Training Courses - Microsoft Office 2016 :
© 2017 Online Training Masters